package com.weilx959.spt.plugin.e2sp.constant;

public class ExcelToSqlConstants {
    private ExcelToSqlConstants() {}

    public static final String TABLE_KEY_COLUMN_PREFIX = "#";
    public static final String DOT = ".";
    public static final String RAW_FUNCTION_PREFIX = "$";
    public static final String NEW_LINE = "\n";
    public static final String COMMA = ",";
    public static final String SEMICOLON = ";";
    public static final String SYSDATE_FUNCTION = "SYSDATE";
    public static final String NOW_FUNCTION = "NOW";

    public static final Dialect DEFAULT_DIALECT = Dialect.ORACLE;
    public static final String DEFAULT_CHECK_SQL_TEMPLATE = "SELECT (CASE COUNT(1) WHEN ${COUNT} THEN '正确' ELSE '错误' END) AS 稽核结果, ${TABLE_NAME_escape} AS 表, ${WHERE_CASE_escape} AS 条件, '@weilx' AS 需求编码 FROM ${TABLE_NAME} WHERE ${WHERE_CASE};";

    public static final String EXCEL_TO_SQL_VIEW = "/com/weilx959/spt/plugin/e2sp/excel-to-sql-view.fxml";
    public static final String EXCEL_TO_SQL_CONFIG_VIEW = "/com/weilx959/spt/plugin/e2sp/excel-to-sql-config-view.fxml";
    public static final String SQL_TO_EXCEL_VIEW = "/com/weilx959/spt/plugin/e2sp/sql-to-excel-view.fxml";
    public static final String EXCEL_SHEET_VIEW = "/com/weilx959/spt/plugin/e2sp/excel-sheet-view.fxml";
    public static final String TABLE_LIST_CELL = "/com/weilx959/spt/plugin/e2sp/table-list-cell.fxml";
    public static final String SUBMIT_FORM_DIALOG = "/com/weilx959/spt/plugin/e2sp/submit-form-dialog.fxml";

    public static final String DATE_FORMAT = "yyyy-MM-dd";
    public static final String TIMESTAMP_FORMAT = "yyyy-MM-dd HH:mm:ss";
    public static final String TIME_FORMAT = "HH:mm:ss";


    public static final String COMMENT_PREFIX = "--";

}
